cm
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | ... | 2782 | 2783 | 2784 | 2785 | 2786 | 2787 | 2788 | 2789 | 2790 | 2791 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1.00 | 0.03 | -0.04 | -0.04 | -0.03 | 0.12 | 0.03 | 0.07 | -0.01 | -0.03 | ... | 0.01 | -0.06 | 0.06 | -0.01 | 0.02 | -0.06 | -0.05 | -0.01 | -0.06 | -0.08 |
| 1 | 0.03 | 1.00 | -0.05 | 0.04 | 0.03 | 0.02 | 0.02 | 0.06 | 0.00 | 0.01 | ... | 0.00 | -0.08 | 0.08 | -0.02 | 0.03 | -0.07 | -0.04 | -0.07 | -0.08 | -0.13 |
| 2 | -0.04 | -0.05 | 1.00 | -0.49 | 0.03 | -0.18 | -0.10 | -0.09 | 0.01 | -0.01 | ... | 0.01 | 0.11 | -0.12 | 0.02 | -0.04 | 0.08 | 0.05 | 0.14 | 0.09 | 0.17 |
| 3 | -0.04 | 0.04 | -0.49 | 1.00 | -0.45 | -0.05 | -0.00 | 0.13 | -0.02 | 0.00 | ... | 0.01 | -0.13 | 0.13 | -0.03 | 0.06 | -0.10 | -0.05 | -0.16 | -0.14 | -0.23 |
| 4 | -0.03 | 0.03 | 0.03 | -0.45 | 1.00 | -0.06 | 0.11 | 0.07 | -0.01 | 0.04 | ... | -0.02 | 0.01 | 0.00 | -0.00 | -0.02 | 0.01 | 0.01 | 0.01 | 0.03 | 0.02 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 2787 | -0.06 | -0.07 | 0.08 | -0.10 | 0.01 | -0.05 | -0.07 | -0.10 | 0.01 | -0.01 | ... | -0.08 | 0.23 | -0.20 | 0.10 | -0.40 | 1.00 | -0.38 | 0.31 | 0.25 | 0.43 |
| 2788 | -0.05 | -0.04 | 0.05 | -0.05 | 0.01 | -0.07 | -0.03 | -0.05 | 0.01 | -0.02 | ... | -0.02 | 0.15 | -0.14 | 0.00 | 0.04 | -0.38 | 1.00 | -0.02 | 0.09 | 0.13 |
| 2789 | -0.01 | -0.07 | 0.14 | -0.16 | 0.01 | -0.12 | -0.10 | -0.08 | -0.04 | -0.00 | ... | -0.05 | 0.34 | -0.32 | 0.15 | -0.22 | 0.31 | -0.02 | 1.00 | 0.14 | 0.72 |
| 2790 | -0.06 | -0.08 | 0.09 | -0.14 | 0.03 | -0.04 | -0.09 | -0.08 | -0.04 | 0.00 | ... | -0.05 | 0.21 | -0.21 | 0.08 | -0.16 | 0.25 | 0.09 | 0.14 | 1.00 | 0.51 |
| 2791 | -0.08 | -0.13 | 0.17 | -0.23 | 0.02 | -0.08 | -0.14 | -0.14 | -0.05 | 0.00 | ... | -0.08 | 0.44 | -0.44 | 0.18 | -0.26 | 0.43 | 0.13 | 0.72 | 0.51 | 1.00 |
2792 rows × 2792 columns
import hvplot.pandas
def get_random_square(df,size=200):
x = randint(0,2792-size)
y = randint(0,2792-size)
return df.iloc[x:x+size,y:y+size]
#df = cm.iloc[:200,:200]
d = get_random_square(cm,300)
d.hvplot.heatmap(width=700,height=700,cmap="PiYG")